ALTER   proc sp_matrix_yield_report

@process_step_id	int,
@process_type 	 	varchar(50),
@lot_number_en		varchar(50),
@from_date		varchar(20),
@to_date		varchar(20),
@default_prompt		varchar(20)

as
begin
	
	declare @result_table table ( 	part_number 	varchar(50), 
					processstep_id 	int,
					lot_number 	varchar(50),
					date_in 	datetime,
					date_out	datetime,
					qty_in		int,--numeric(9,2),
					qty_out		int,--numeric(9,2),
					gross_die	int,
					yield		float,
					location	varchar(50),
					process		varchar(50),
					process_type_id int,
					fab_lot_number	varchar(50))

	
		insert @result_table select * from fn_matrix_yield_report ( @process_step_id,@process_type,@lot_number_en,@from_date,@to_date)

	
	select * from @result_table

end